<?php
namespace backend\models;

use Yii;
use yii\base\NotSupportedException;
use yii\behaviors\TimestampBehavior;
use yii\db\ActiveRecord;
use yii\web\IdentityInterface;
use yii\db\Query;

/**
 * User model
 *
 * @property integer $id
 * @property string $username
 * @property string $password_hash
 * @property string $password_reset_token
 * @property string $email
 * @property string $auth_key
 * @property integer $status
 * @property integer $created_at
 * @property integer $updated_at
 * @property string $password write-only password
 */
class Member extends ActiveRecord implements IdentityInterface
{
    const STATUS_DELETED = 0;
    const STATUS_ACTIVE = 10;
    const STATUS = 1;

    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return '{{%member}}';
    }

    /**
     * @inheritdoc
     */
    public function behaviors()
    {
        return [
            TimestampBehavior::className(),
        ];
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['username', 'password'], 'trim'],
//            [['username', 'password'], 'required'],
        ];
    }

    public static function saveData($id,$auth){
        $admin = Member::findOne(['id' => $id]);
        $admin->is_auth = $auth;
        return $admin->save();
    }

    /**
     * @inheritdoc
     */
    public static function findFieldData($where,$field)
    {
        $query = new \yii\db\Query();
        $query->select($field)->from('member');
        $query->where(['deleted_at' => null]);
        $query->orderBy([
            'created_at' => SORT_DESC,
        ]);
        if(!empty($where)){
            $query->andWhere($where);
        }

        $command = $query->createCommand();
        $result = $command->queryOne();
        return $result;
    }

    /**
     * @inheritdoc
     */
    public static function selectFieldData($field)
    {
        $query = new \yii\db\Query();
        $query->select($field)->from('member');
        $query->where(['deleted_at' => null]);
        $query->orderBy([
            'created_at' => SORT_DESC,
        ]);

        $command = $query->createCommand();
        $result = $command->queryAll();
        return $result;
    }

    /**
     * @inheritdoc
     */
    public static function selectInfo($data = [])
    {
        $query = new \yii\db\Query();
        $query->select(['*'])->from('member');
        $query->where(['deleted_at' => null]);
        $query->orderBy([
            'created_at' => SORT_DESC,
        ]);
        if(!empty($data['start_date']) && !empty($data['end_date'])){
            $query->andFilterWhere(['between','created_at',$data['start_date'], $data['end_date']]);
        }
        if(!empty($data['province_id'])){
            $query->andWhere(['province_id' => $data['province_id']]);
        }
        $command = $query->createCommand();
        $result = $command->queryAll();
        return $result;
    }

    /**
     * @inheritdoc
     */
    public static function selectData($field,$data)
    {
        $district = new \backend\models\District();
        $condition = 'deleted_at is null';
        if(!empty($data['mobile'])){
            $condition .= " and mobile like '%".$data['mobile']."%'";
        }
        if(!empty($data['is_auth'])){
            $condition .= " and is_auth =".$data['is_auth'];
        }
        if(!empty($data['group_id'])){
            $model = new \backend\models\GroupMember();
            $res = $model::selectData(['`member_id`'],$data['group_id']);
            $data = [];
            foreach ($res as $k => $v){
                $data[] = $v['member_id'];
            }
            if(empty($data)){
                $condition .= " and id = 0";
            }else{
                $info = implode(',',$data);
                $condition .= " and id in (".$info.")";
            }
        }
        $list = (new Query())
            ->select($field)
            ->from('member')
            ->orderBy('created_at desc')
            ->where($condition)
            ->all();
        if(!empty($list)){
            foreach ($list as $k => $v){
                $list[$k]['created_at'] = date('Y-m-d H:i:s',$v['created_at']);
                if(!empty($data['city'])){
                    $city = $district::findOne(['front_code' => $v['city_id']]);
                    $list[$k]['city'] = empty($city['district'])?'':$city['district'];
                }
            }
        }
        return empty($list)?array():$list;
    }

    /**
     * @inheritdoc
     */
    public static function findAllData($mobile,$page = 1,$pageSize = 10)
    {
        $query = new \yii\db\Query();
        $query->select(['*'])->from('member');
        $query->where(['status' => self::STATUS]);
        if(!empty($mobile)){
            $query->andWhere(['like', 'mobile', $mobile]);
        }
        $page = $page ? $page : 1;
        $pageSize = $pageSize ? $pageSize : 10;
        $query->offset(($page - 1) * $pageSize)->limit($pageSize);
        $command = $query->createCommand();
        $result = $command->queryAll();
        return $result;
    }

    /**
     * @inheritdoc
     */
    public static function findIdentity($id)
    {
        return static::findOne(['id' => $id, 'status' => self::STATUS]);
    }

    /**
     * @inheritdoc
     */
    public static function findDataByUsername($username)
    {
        return static::findOne(['username' => $username, 'status' => self::STATUS]);
    }

    /**
     * @inheritdoc
     */
    public static function findIdentityByAccessToken($token, $type = null)
    {
        throw new NotSupportedException('"findIdentityByAccessToken" is not implemented.');
    }

    /**
     * Finds user by username
     *
     * @param string $username
     * @return static|null
     */
    public static function findByUsername($username)
    {
        return static::findOne(['username' => $username, 'status' => self::STATUS_ACTIVE]);
    }

    /**
     * Finds user by password reset token
     *
     * @param string $token password reset token
     * @return static|null
     */
    public static function findByPasswordResetToken($token)
    {
        if (!static::isPasswordResetTokenValid($token)) {
            return null;
        }

        return static::findOne([
            'password_reset_token' => $token,
            'status' => self::STATUS_ACTIVE,
        ]);
    }

    /**
     * Finds out if password reset token is valid
     *
     * @param string $token password reset token
     * @return bool
     */
    public static function isPasswordResetTokenValid($token)
    {
        if (empty($token)) {
            return false;
        }

        $timestamp = (int) substr($token, strrpos($token, '_') + 1);
        $expire = Yii::$app->params['user.passwordResetTokenExpire'];
        return $timestamp + $expire >= time();
    }

    /**
     * @inheritdoc
     */
    public function getId()
    {
        return $this->getPrimaryKey();
    }

    /**
     * @inheritdoc
     */
    public function getAuthKey()
    {
        return $this->auth_key;
    }

    /**
     * @inheritdoc
     */
    public function validateAuthKey($authKey)
    {
        return $this->getAuthKey() === $authKey;
    }

    /**
     * Validates password
     *
     * @param string $password password to validate
     * @return bool if password provided is valid for current user
     */
    public function validatePassword($password)
    {
        return Yii::$app->security->validatePassword($password, $this->password_hash);
    }

    /**
     * Generates password hash from password and sets it to the model
     *
     * @param string $password
     */
    public function setPassword($password)
    {
        $this->password_hash = Yii::$app->security->generatePasswordHash($password);
    }

    /**
     * Generates "remember me" authentication key
     */
    public function generateAuthKey()
    {
        $this->auth_key = Yii::$app->security->generateRandomString();
    }

    /**
     * Generates new password reset token
     */
    public function generatePasswordResetToken()
    {
        $this->password_reset_token = Yii::$app->security->generateRandomString() . '_' . time();
    }

    /**
     * Removes password reset token
     */
    public function removePasswordResetToken()
    {
        $this->password_reset_token = null;
    }
}
